Resolve dynamic column referencing in Excel 2016 by using INDEX MATCH or INDIRECT to convert cell text into live table column references.